package com.example.mapper;

import com.example.pojo.entity.JobRecruiter;
import com.example.pojo.entity.Post;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 用于演示 :获取招聘者及其公司的信息并展示
 *
 * @author : gao'm
 */
public interface GeekJobMapper {
//    @Select("select * from post where pos_name or recruitment_agency like #{value}")
    List<Post> findPost(String searchkey);

    @Select("select company_name,company_type,employees_quantity,run_state,jr_avatar,jr_name,jr_type from job_recruiter where id=#{value}")
    JobRecruiter findJr(Integer id);

    @Select("select * from post where recruitment_agency =#{value}")
    List<Post> findSameCompanyPost(String companyname);

}
